package com.olivia.peanut.aps.service.impl.po;

public interface ApsOrderConfig {

  String DELETE_ORDER_ALL = """
      truncate table aps_order;
      truncate table aps_order_goods;
      truncate table aps_order_goods_forecast_make;
      truncate table aps_order_goods_project_config;
      truncate table aps_order_goods_sale_config;
      truncate table aps_order_goods_status_date;
      truncate table aps_order_goods_bom;
      truncate table aps_rolling_forecast_order_item;
      truncate table aps_order_user;
      truncate table aps_scheduling_day_config_version;
      truncate table aps_scheduling_day_config_version_detail;
      truncate table aps_scheduling_day_config_version_detail_machine;
      truncate table aps_scheduling_day_config_version_detail_machine_use_time;
      truncate table aps_scheduling_goods_bom;
      truncate table aps_scheduling_goods_bom_total;
      truncate table aps_scheduling_goods_status_date;
      truncate table aps_scheduling_issue_item;
      truncate table aps_scheduling_version;
      truncate table aps_scheduling_version_capacity;
      truncate table aps_scheduling_version_day;
      truncate table aps_scheduling_version_item;
      truncate table aps_scheduling_version_item_pre;
      truncate table aps_scheduling_version_limit;
      truncate table aps_goods_bom_buy_plan;
      truncate table aps_goods_bom_buy_plan_item;
      truncate table aps_rolling_forecast_order;
      truncate table aps_order_goods_history;
      truncate table aps_order_goods_sale_config_history;
      truncate table aps_order_goods_bom_kitting_version;
      truncate table aps_order_goods_bom_kitting_version_order;
      truncate table aps_order_goods_bom_kitting_version_order_bom;
      truncate table aps_goods_forecast;
      truncate table aps_goods_forecast_compute_sale_data;
      truncate table aps_goods_forecast_main;
      truncate table aps_goods_forecast_main_goods_data;
      truncate table aps_goods_forecast_main_make;
      truncate table aps_goods_forecast_main_make_sale_data;
      truncate table aps_goods_forecast_main_sale_data;
      truncate table aps_goods_forecast_make;
      truncate table aps_goods_forecast_make_bom_use;
      truncate table aps_goods_forecast_make_project_data;
      truncate table aps_goods_forecast_make_sale_data;
      truncate table aps_goods_forecast_user_goods_data;
      truncate table aps_goods_forecast_user_sale_data;
      truncate table aps_goods_forecast_user_sale_group_data;
      ANALYZE TABLE aps_order;
      ANALYZE TABLE aps_order_goods;
      ANALYZE TABLE aps_order_goods_forecast_make;
      ANALYZE TABLE aps_order_goods_project_config;
      ANALYZE TABLE aps_order_goods_sale_config;
      ANALYZE TABLE aps_order_goods_status_date;
      ANALYZE TABLE aps_order_goods_bom;
      ANALYZE TABLE aps_rolling_forecast_order_item;
      ANALYZE TABLE aps_order_user;
      ANALYZE TABLE aps_scheduling_day_config_version;
      ANALYZE TABLE aps_scheduling_day_config_version_detail;
      ANALYZE TABLE aps_scheduling_day_config_version_detail_machine;
      ANALYZE TABLE aps_scheduling_day_config_version_detail_machine_use_time;
      ANALYZE TABLE aps_scheduling_goods_bom;
      ANALYZE TABLE aps_scheduling_goods_bom_total;
      ANALYZE TABLE aps_scheduling_goods_status_date;
      ANALYZE TABLE aps_scheduling_issue_item;
      ANALYZE TABLE aps_scheduling_version;
      ANALYZE TABLE aps_scheduling_version_capacity;
      ANALYZE TABLE aps_scheduling_version_day;
      ANALYZE TABLE aps_scheduling_version_item;
      ANALYZE TABLE aps_scheduling_version_item_pre;
      ANALYZE TABLE aps_scheduling_version_limit;
      ANALYZE TABLE aps_goods_bom_buy_plan;
      ANALYZE TABLE aps_goods_bom_buy_plan_item;
      ANALYZE TABLE aps_rolling_forecast_order;
      ANALYZE TABLE aps_order_goods_history;
      ANALYZE TABLE aps_order_goods_sale_config_history;
      ANALYZE TABLE aps_order_goods_bom_kitting_version;
      ANALYZE TABLE aps_order_goods_bom_kitting_version_order;
      ANALYZE TABLE aps_order_goods_bom_kitting_version_order_bom;
      ANALYZE TABLE aps_goods_forecast;
      ANALYZE TABLE aps_goods_forecast_compute_sale_data;
      ANALYZE TABLE aps_goods_forecast_main;
      ANALYZE TABLE aps_goods_forecast_main_goods_data;
      ANALYZE TABLE aps_goods_forecast_main_make;
      ANALYZE TABLE aps_goods_forecast_main_make_sale_data;
      ANALYZE TABLE aps_goods_forecast_main_sale_data;
      ANALYZE TABLE aps_goods_forecast_make;
      ANALYZE TABLE aps_goods_forecast_make_bom_use;
      ANALYZE TABLE aps_goods_forecast_make_project_data;
      ANALYZE TABLE aps_goods_forecast_make_sale_data;
      ANALYZE TABLE aps_goods_forecast_user_goods_data;
      ANALYZE TABLE aps_goods_forecast_user_sale_data;
      ANALYZE TABLE aps_goods_forecast_user_sale_group_data;
      OPTIMIZE TABLE aps_order;
      OPTIMIZE TABLE aps_order_goods;
      OPTIMIZE TABLE aps_order_goods_forecast_make;
      # rename table aps_rolling_forecast_order_item to aps_rolling_forecast_order_item;
      # rename table aps_order_goods_project_config to aps_order_goods_project_config;
      # rename table aps_order_goods_status_date to aps_order_goods_status_date;
      # rename table aps_order_goods_sale_config to aps_order_goods_sale_config;
      OPTIMIZE TABLE aps_order_goods_project_config;
      OPTIMIZE TABLE aps_order_goods_sale_config;
      OPTIMIZE TABLE aps_order_goods_status_date;
      OPTIMIZE TABLE aps_order_goods_bom;
      OPTIMIZE TABLE aps_rolling_forecast_order_item;
      OPTIMIZE TABLE aps_order_user;
      OPTIMIZE TABLE aps_scheduling_day_config_version;
      OPTIMIZE TABLE aps_scheduling_day_config_version_detail;
      OPTIMIZE TABLE aps_scheduling_day_config_version_detail_machine;
      OPTIMIZE TABLE aps_scheduling_day_config_version_detail_machine_use_time;
      OPTIMIZE TABLE aps_scheduling_goods_bom;
      OPTIMIZE TABLE aps_scheduling_goods_bom_total;
      OPTIMIZE TABLE aps_scheduling_goods_status_date;
      OPTIMIZE TABLE aps_scheduling_issue_item;
      OPTIMIZE TABLE aps_scheduling_version;
      OPTIMIZE TABLE aps_scheduling_version_capacity;
      OPTIMIZE TABLE aps_scheduling_version_day;
      OPTIMIZE TABLE aps_scheduling_version_item;
      OPTIMIZE TABLE aps_scheduling_version_item_pre;
      OPTIMIZE TABLE aps_scheduling_version_limit;
      OPTIMIZE TABLE aps_goods_bom_buy_plan;
      OPTIMIZE TABLE aps_goods_bom_buy_plan_item;
      OPTIMIZE TABLE aps_rolling_forecast_order;
      OPTIMIZE TABLE aps_order_goods_history;
      OPTIMIZE TABLE aps_order_goods_sale_config_history;
      OPTIMIZE TABLE aps_order_goods_bom_kitting_version;
      OPTIMIZE TABLE aps_order_goods_bom_kitting_version_order;
      OPTIMIZE TABLE aps_order_goods_bom_kitting_version_order_bom;
      OPTIMIZE TABLE aps_goods_forecast;
      OPTIMIZE TABLE aps_goods_forecast_compute_sale_data;
      OPTIMIZE TABLE aps_goods_forecast_main;
      OPTIMIZE TABLE aps_goods_forecast_main_goods_data;
      OPTIMIZE TABLE aps_goods_forecast_main_make;
      OPTIMIZE TABLE aps_goods_forecast_main_make_sale_data;
      OPTIMIZE TABLE aps_goods_forecast_main_sale_data;
      OPTIMIZE TABLE aps_goods_forecast_make;
      OPTIMIZE TABLE aps_goods_forecast_make_bom_use;
      OPTIMIZE TABLE aps_goods_forecast_make_project_data;
      OPTIMIZE TABLE aps_goods_forecast_make_sale_data;
      OPTIMIZE TABLE aps_goods_forecast_user_goods_data;
      OPTIMIZE TABLE aps_goods_forecast_user_sale_data;
      OPTIMIZE TABLE aps_goods_forecast_user_sale_group_data;
      
      """;

}
